{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["1","2","3","4","5","6","7","8","9","10","11","12","13","Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"1","index":0,"n_rows":41,"n_cols":19,"rows_kept":41,"merged":[[0,0,0,2],[1,10,1,16],[2,10,2,14],[3,10,3,14],[6,0,6,17],[7,0,7,17],[8,0,10,0],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,10,6],[8,7,10,7],[8,8,10,8],[8,9,10,9],[8,10,9,11],[8,12,8,17],[9,12,9,13],[9,14,9,15],[9,16,9,17],[11,0,11,1],[12,0,17,0],[18,1,19,1],[28,0,31,0],[32,0,34,0],[32,1,34,1],[36,0,39,0],[40,0,40,1]]}
[]
["Согласовано:",{"$nulls":9},"\"Утверждаю\""]
["Начальник отдела образования",{"$nulls":9},"Директор МБОУ \"Олуязский лицей\""]
[" исполнительного комитета",{"$nulls":9},"__________________  Хасанов А.Г."]
["Мамадышского муниципального района"]
[null,"И.Н. Габдрахманов"]
["Примерное двухнедельное меню школьных завтраков  для организации питания детей , с 11 и старше.С прибыванием детей до 6 часов"]
["                                            Использован: Сборник рецептур блюд и кулинарных изделий для предприятий общетвенного питания 1993 и 1996гг.Сборник рецептур блюд и кулинарный изделий татарской нацинальной кухни 1997г."]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["1 день"]
["№10","салат из свежей  капусты ","капуста",99.6,79,null,1.4,null,3.7,21.3,25,{"$f":"D13*K13/1000","v":2.49},null,{"$f":"D13*M13/1000","v":{"v":0,"d":"0.00"}},20.8,{"$f":"D13*O13/1000","v":{"v":2.0716799999999997,"d":"2.07"}},null,{"$f":"D13*Q13/1000","v":0}]
[null,null,"лук",12.5,10,null,0.14,null,0.91,4.1,30,{"$f":"D14*K14/1000","v":{"v":0.375,"d":"0.38"}},null,{"$f":"D14*M14/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D14*O14/1000","v":{"v":0.3125,"d":"0.31"}},null,{"$f":"D14*Q14/1000","v":0}]
[null,null,"морковь",12.5,10,null,0.1,null,0.7,3.4,35,{"$f":"D15*K15/1000","v":{"v":0.4375,"d":"0.44"}},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D15*O15/1000","v":{"v":0.3125,"d":"0.31"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,null,"сахар",5,5,{"$nulls":3},4.9,18.9,80,{"$f":"D16*K16/1000","v":{"v":0.4,"d":"0.40"}},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},44.49,{"$f":"D16*Q16/1000","v":0.22245}]
[null,null,"масло растительное ",5,5,null,null,4.99,null,44.9,140,{"$f":"D17*K17/1000","v":{"v":0.7,"d":"0.70"}},57.58,{"$f":"D17*M17/1000","v":{"v":0.2879,"d":"0.29"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},57.58,{"$f":"D17*Q17/1000","v":0.2879}]
[null,null,"итого",null,null,100,{"$f":"SUM(G13:G17)","v":1.6400000000000001},4.99,10.21,92.6,310,4.4025,57.58,0.2879,70.8,2.6966799999999997,102.07,0.51035]
["№610","Биточки из говядины","Говядина",34,25,null,6.32,4.08,null,55.59,440,{"$f":"D19*K19/1000","v":14.96},null,{"$f":"D19*M19/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D19*O19/1000","v":{"v":0,"d":"0.00"}},300.82,{"$f":"D19*Q19/1000","v":10.227879999999999}]
[null,null,"Жир-сырец",4.47,4.47,null,null,4.46,null,40.01,440,{"v":1.9667999999999999,"d":"1.97"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},300.82,1.3446653999999998]
[null,null,"Лук репчатый",0.6,0.6,null,"-","-","-",0.21,30,{"v":0.018,"d":"0.02"},null,{"v":0,"d":"0.00"},25,{"v":0.015,"d":"0.02"},null,0]
[null,null,"Сухари",1,2,null,0.22,0.02,1.44,6.62,100,{"v":0.1,"d":"0.10"},54.8,{"v":0.054799999999999995,"d":"0.05"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Хлеб ржанойй",7,7,null,0.57,0.06,0.47,15.82,51,{"v":0.357,"d":"0.36"},44.98,{"v":0.31486,"d":"0.31"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",0.6,0.6,null,"-","-","-","-",16,{"v":0.0096,"d":"0.01"},9.5,{"v":0.0057,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масса п/ф",null,50,null,"-",null,"-","-",null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масло растительное",2,2,null,"-",1.99,"-",17.98,140,0.28,57.58,{"v":0.11516,"d":"0.12"},null,{"v":0,"d":"0.00"},null,0]
[{"$nulls":5},41,{"$f":"SUM(G19:G26)","v":7.11},10.61,1.91,136.23,1217,17.6914,166.86,0.49051999999999996,25,0.015,601.64,11.5725454]
[{"$nulls":11},{"$f":"D28*K28/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D28*M28/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D28*O28/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D28*Q28/1000","v":0}]
["№746","Каша гречневая","Крупа гречневая",50,null,null,5.9,1.65,30.95,167.5,100,{"$f":"D29*K29/1000","v":{"v":5,"d":"5.00"}},27.69,{"$f":"D29*M29/1000","v":{"v":1.3845,"d":"1.38"}},null,{"$f":"D29*O29/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D29*Q29/1000","v":0}]
[null,null,"Масло сливочное",5,null,null,0.04,3.6,0.06,33.05,530,{"$f":"D30*K30/1000","v":2.65},447.02,{"$f":"D30*M30/1000","v":{"v":2.2351,"d":"2.24"}},null,{"$f":"D30*O30/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D30*Q30/1000","v":0}]
[null,null,"Соль",0.5,null,null,"-","-",null,null,16,{"$f":"D31*K31/1000","v":{"v":0.008,"d":"0.01"}},9.5,{"$f":"D31*M31/1000","v":{"v":0.00475,"d":"0.00"}},null,{"$f":"D31*O31/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D31*Q31/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G29:G31)","v":5.94},5.25,31.009999999999998,200.55,646,7.658,484.21,3.62435,0,0,0,0]
["№944","Чай с сахаром","Заварка",1,1,null,0.04,"-","-",null,688,{"$f":"D33*K33/1000","v":{"v":0.688,"d":"0.69"}},200,{"$f":"D33*M33/1000","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D33*O33/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D33*Q33/1000","v":0}]
[null,null,"Сахар",15,15,null,0,null,14.9,58,80,{"$f":"D34*K34/1000","v":{"v":1.2,"d":"1.20"}},44.49,{"$f":"D34*M34/1000","v":{"v":0.66735,"d":"0.67"}},null,{"$f":"D34*O34/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D34*Q34/1000","v":0}]
[null,null,"итого",null,null,"200/7",{"$f":"SUM(G33:G34)","v":0.04},0,14.9,58,0,1.888,244.49,0.8673500000000001,0,0,0,0]
[null,"хлеб","хлеб",40,null,40,12.16,1.44,79.76,180.8,60,{"$f":"D36*K36/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D36*M36/1000","v":{"v":2.192,"d":"2.19"}},null,{"$f":"D36*O36/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D36*Q36/1000","v":0}]
[null,"Вафли","Вафли",50,50,50,2.15,16.05,32.5,280.5,200,{"$f":"D37*K37/1000","v":{"v":10,"d":"10.00"}},null,{"$f":"D37*M37/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D37*O37/1000","v":{"v":0,"d":"0.00"}},89,{"$f":"D37*Q37/1000","v":4.45}]
[{"$nulls":11},{"$f":"D38*K38/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D38*M38/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D38*O38/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D38*Q38/1000","v":0}]
[null,null,"итого",null,null,50,{"$f":"SUM(G37:G38)","v":2.15},16.05,32.5,280.5,200,10,0,0,0,0,89,4.45]
[{"$nulls":6},{"$f":"G18+G27+G32+G35+G36+G39","v":29.04},38.34,170.29,948.6800000000001,2433,44.0399,1007.9399999999999,{"v":7.4621200000000005,"d":"7.46"},95.8,2.71168,792.71,{"v":16.5328954,"d":"16.53"},{"$f":"N40+R40","v":{"v":23.9950154,"d":"24.00"}}]
["итого за день"]

{"sheet":"2","index":1,"n_rows":32,"n_cols":19,"rows_kept":32,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,6,0],[7,0,13,0],[14,0,17,0],[14,1,16,1],[31,0,31,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№273"]
[]
[]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G6)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"каша \"Дружба\"","рис",16.6,16.6,null,1.16,0.16,11.8,52.55,75,{"$f":"D8*K8/1000","v":{"v":1.245,"d":"1.25"}},39,{"$f":"D8*M8/1000","v":{"v":0.6474000000000001,"d":"0.65"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,null,"пшено ",18,17.8,null,2.07,0.59,11.96,62.01,51,{"v":0.918,"d":"0.92"},49.31,{"v":0.88758,"d":"0.89"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"молоко",72.9,72.9,null,2.03,2.55,3.42,44.47,62,{"v":4.5198,"d":"4.52"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},46.34,3.378186000000001]
[null,null,"сахар",7.5,7.5,{"$nulls":3},7.48,28.43,80,{"v":0.6,"d":"0.60"},51.92,{"v":0.3894,"d":"0.39"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"масло сливочное ",5,null,null,0.04,3.63,0.13,33.05,530,2.65,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},447.02,2.2351]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,100,{"$f":"SUM(G8:G13)","v":{"v":5.3,"d":"5.30"}},{"$f":"SUM(H8:H13)","v":6.93},34.79,220.51,null,{"v":9.9488,"d":"9.95"},null,{"v":1.93388,"d":"1.93"},null,{"v":0,"d":"0.00"},null,{"v":5.613286,"d":"5.61"}]
["№944","Какао с молоком","Какао",4,null,null,0.19,0.14,0.3,null,271,{"$f":"D15*K15/1000","v":{"v":1.084,"d":"1.08"}},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,null,"Молоко",100,null,null,2.82,3.2,4.73,58,62,{"$f":"D16*K16/1000","v":{"v":6.2,"d":"6.20"}},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},46.34,{"$f":"D16*Q16/1000","v":4.634}]
[null,null,"Сахар",20,{"$nulls":4},19.96,75.8,80,{"$f":"D17*K17/1000","v":{"v":1.6,"d":"1.60"}},44.49,{"$f":"D17*M17/1000","v":{"v":0.8898,"d":"0.89"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D17*Q17/1000","v":0}]
[{"$nulls":5},200,{"$f":"SUM(G15:G17)","v":3.01},{"$f":"SUM(H15:H17)","v":3.3400000000000003},{"$f":"SUM(I15:I17)","v":24.990000000000002},{"$f":"SUM(J15:J17)","v":133.8},null,{"$f":"SUM(L15:L17)","v":8.884},null,{"$f":"SUM(N15:N17)","v":0.8898},null,{"$f":"SUM(P15:P17)","v":0},null,{"$f":"SUM(R15:R17)","v":4.634}]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,{"$f":"D19*K19/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D19*M19/1000","v":{"v":2.192,"d":"2.19"}},{"$f":"G19*N19/1000","v":{"v":0,"d":"0.00"}},{"$f":"D19*O19/1000","v":{"v":0,"d":"0.00"}},{"$f":"I19*P19/1000","v":{"v":0,"d":"0.00"}},{"$f":"D19*Q19/1000","v":0}]
[null,"яблоко",null,150,{"$nulls":6},90,{"$f":"D20*K20/1000","v":{"v":13.5,"d":"13.50"}},null,{"$f":"D20*M20/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D20*O20/1000","v":{"v":0,"d":"0.00"}},{"v":59,"d":"59.00"},{"$f":"D20*Q20/1000","v":8.85}]
[{"$nulls":11},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,0]
["№10","ватрушки с творогом","мука",37,37,null,{"v":4.02,"d":"4.0"},null,{"v":25,"d":"25.0"},{"v":121,"d":"121.0"},{"v":40,"d":"40.0"},{"$f":"D22*K22/1000","v":1.48},{"v":22.39,"d":"22.4"},{"$f":"D22*M22/1000","v":{"v":0.8284300000000001,"d":"0.83"}},null,{"$f":"D22*O22/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D22*Q22/1000","v":0}]
[null,null,"сахар",2,2,{"$nulls":3},1.9,7.5,{"v":80,"d":"80.0"},0.16,44.5,{"v":0.089,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"масло сливочное ",1.68,1.68,null,{"v":0.01,"d":"0.0"},{"v":1.45,"d":"1.5"},{"v":0.02,"d":"0.0"},13.2,{"v":530,"d":"530.0"},{"v":0.8904,"d":"0.89"},{"v":447.02,"d":"447.0"},{"v":0.7509935999999999,"d":"0.75"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"соль ",0.005,0.005,{"$nulls":5},{"v":16,"d":"16.0"},{"v":8e-05,"d":"0.00"},9.5,{"v":4.75e-05,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"дрожжи",1.1,1.1,{"$nulls":5},{"v":400,"d":"400.0"},{"v":0.44000000000000006,"d":"0.44"},{"v":240,"d":"240.0"},{"v":0.264,"d":"0.26"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"фарш: творог",25.2,25.2,null,4.5,{"v":0.15,"d":"0.2"},{"v":0.45,"d":"0.5"},22.1,{"v":300,"d":"300.0"},7.56,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},278.89,7.028027999999999]
[null,null,"яйцо",2.4,2.4,null,{"v":0.43,"d":"0.4"},{"v":0.39,"d":"0.4"},{"v":0.02,"d":"0.0"},5.3,137.5,0.33,137.5,0.33,null,{"v":0,"d":"0.00"},null,0]
[null,null,"сахар",2.4,2.4,{"$nulls":3},{"v":0.02,"d":"0.0"},{"v":9,"d":"9.0"},{"v":80,"d":"80.0"},{"v":0.192,"d":"0.19"},{"v":44.49,"d":"44.5"},{"v":0.106776,"d":"0.11"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Яйцо для смазки",0.025,0.025,{"$nulls":5},137.5,{"v":3.4375E-3,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,75,{"$f":"SUM(G22:G29)","v":{"v":8.959999999999999,"d":"9.0"}},{"$f":"SUM(H22:H29)","v":{"v":1.9899999999999998,"d":"2.0"}},{"v":27.409999999999997,"d":"27.4"},178.1,{"$f":"SUM(K22:K30)","v":{"v":1721,"d":"1721.0"}},{"v":11.05248,"d":"11.1"},945.4,{"v":2.3692471,"d":"2.4"},{"v":0,"d":"0.0"},{"$f":"SUM(P22:P30)","v":{"v":0,"d":"0.0"}},{"v":278.89,"d":"278.9"},{"$f":"SUM(R22:R30)","v":{"v":7.028027999999999,"d":"7.0"}}]
["итого за день",{"$nulls":5},{"$f":"G31+G19+G18+G14","v":17.27},{"$f":"H31+H19+H18+H14","v":{"v":13.459999999999999,"d":"13.46"}},{"$f":"I31+I19+I18+I14","v":133.19},{"$f":"J31+J19+J18+J14","v":{"v":699.6099999999999,"d":"699.61"}},{"$f":"K31+K19+K18+K14","v":{"v":1781,"d":"1781.00"}},{"$f":"L31+L19+L18+L14+L7","v":{"v":32.28528,"d":"32.29"}},{"v":1000.1999999999999,"d":"1000.20"},{"v":7.3849271000000005,"d":"7.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},278.89,26.13,{"$f":"N32+R32","v":{"v":33.5149271,"d":"33.51"}}]

{"sheet":"3","index":2,"n_rows":30,"n_cols":19,"rows_kept":30,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[25,0,28,0],[25,1,26,1],[29,0,29,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"салат свекольный","Свекла",116,null,null,1.1,null,5.43,28.9,{"v":15,"d":"15.00"},{"$f":"D4*K4/1000","v":1.74},null,{"$f":"D4*M4/1000","v":{"v":0,"d":"0.00"}},20,{"$f":"D4*O4/1000","v":2.32},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"Масло растительное",10,null,null,"-",9.9,null,89.9,{"v":140,"d":"140.00"},{"$f":"D5*K5/1000","v":{"v":1.4,"d":"1.40"}},57.58,{"$f":"D5*M5/1000","v":{"v":0.5758,"d":"0.58"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"Сахар",5,null,null,"-",4.9,null,18.9,{"v":80,"d":"80.00"},{"$f":"D6*K6/1000","v":{"v":0.4,"d":"0.40"}},null,{"$f":"D6*M6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},44.49,{"$f":"D6*Q6/1000","v":0.22245}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G6)","v":1.1},{"$f":"SUM(H4:H6)","v":14.8},5.43,137.70000000000002,235,3.5399999999999996,57.58,0.5758,20,2.32,44.49,0.22245]
[]
["№746","картофельное пюре ","картофель ",233,150,null,2,0.4,16.3,80,25,{"$f":"D9*K9/1000","v":{"v":5.825,"d":"5.83"}},null,{"$f":"D9*M9/1000","v":{"v":0,"d":"0.00"}},20,4.31]
[null,null,"молоко ",23.7,null,null,6.4,0.39,0.74,8.2,62,{"$f":"D10*K10/1000","v":{"v":1.4693999999999998,"d":"1.47"}},37.55,{"$f":"D10*M10/1000","v":{"v":0.8899349999999999,"d":"0.89"}},37.55,0.89,null,{"$f":"D10*Q10/1000","v":0}]
[null,null,"Соль",1.5,null,null,"-","-","-","-",16,{"$f":"D11*K11/1000","v":{"v":0.024,"d":"0.02"}},10.06,{"$f":"D11*M11/1000","v":{"v":0.01509,"d":"0.02"}},10.06,0.02,null,{"$f":"D11*Q11/1000","v":0}]
[null,null,"Масло слив",5,null,null,0.02,2.5,0.04,23.1,530,{"$f":"D12*K12/1000","v":2.65},253.4,{"$f":"D12*M12/1000","v":{"v":1.267,"d":"1.27"}},253.4,1.27,null,{"$f":"D12*Q12/1000","v":0}]
[null,null,"итого",null,null,150,{"$f":"SUM(G9:G12)","v":8.42},{"$f":"SUM(H9:H12)","v":3.29},17.08,111.30000000000001,633,9.968399999999999,301.01,2.1720249999999997,321.01,6.48,0,6.48]
[]
[{"$nulls":11},{"$f":"D15*K15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,"Рыба тушеная","рыбные изделия",86,50,null,27.4,5.24,0,110,170,14.62,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":169,"d":"169.0"},14.534]
[null,null,"Масло растительное",4,4,null,null,5.99,0,53.94,140,0.56,57.58,{"v":0.23032,"d":"0.23"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Мука пшеничная",4,4,null,0.62,0.06,4.13,20.04,40,0.16,22.39,{"v":0.08956,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,1,{"$nulls":5},16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"специи",{"v":0.02,"d":"0"},{"v":0.02,"d":"0"},{"$nulls":6},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[{"$nulls":5},"50",{"$f":"SUM(G16:G20)","v":28.02},{"$f":"SUM(H16:H20)","v":{"v":11.290000000000001,"d":"11.29"}},4.13,183.98,{"v":366,"d":"366.00"},{"v":15.356,"d":"15.36"},null,{"v":0.32938,"d":"0.33"},null,{"v":0,"d":"0.00"},null,{"v":14.534,"d":"14.53"}]
[944,"Чай с сахаром","Заварка",1,1,null,null,"-","-","-",688,{"$f":"D22*K22/1000","v":{"v":0.688,"d":"0.69"}},260,{"$f":"D22*M22/1000","v":0.26},null,{"$f":"D22*O22/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D22*Q22/1000","v":0}]
[null,null,"Сахар",15,15,null,0,"-",14.9,56.8,80,{"$f":"D23*K23/1000","v":{"v":1.2,"d":"1.20"}},44.49,{"$f":"D23*M23/1000","v":{"v":0.66735,"d":"0.67"}},null,{"$f":"D23*O23/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D23*Q23/1000","v":0}]
[null,null,"итого",null,null,200,{"$f":"SUM(G22:G23)","v":0},{"$f":"SUM(H22:H23)","v":0},14.9,56.8,null,1.888,null,0.92735,null,0,null,0]
[null,"хлеб иодированный","хлеб",40,40,40,6.96,1.2,46,167.2,60,{"$f":"D25*K25/1000","v":{"v":2.4,"d":"2.40"}},44.98,{"$f":"D25*M25/1000","v":{"v":1.7992,"d":"1.80"}},null,{"$f":"D25*O25/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D25*Q25/1000","v":0}]
[null,"Печенье",{"$nulls":9},{"$f":"D26*K26/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D26*M26/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"печенье",30,null,null,8,12,67,410,130,{"$f":"D27*K27/1000","v":{"v":3.9,"d":"3.90"}},57,{"$f":"D27*M27/1000","v":1.71}]
[]
[{"$nulls":6},{"$f":"SUM(G26:G28)","v":8},{"$f":"SUM(H26:H28)","v":12},{"$f":"SUM(I26:I28)","v":67},{"$f":"SUM(J26:J28)","v":410},null,{"$f":"SUM(L26:L28)","v":{"v":3.9,"d":"3.90"}},{"v":57,"d":"57.00"},1.71,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Итого за день",{"$nulls":5},{"$f":"G29+G25+G24+G21","v":{"v":42.980000000000004,"d":"42.980"}},{"$f":"H29+H25+H24+H21","v":{"v":24.490000000000002,"d":"24.490"}},{"$f":"I29+I25+I24+I21","v":{"v":132.03,"d":"132.030"}},{"$f":"J29+J25+J24+J21","v":{"v":817.98,"d":"817.980"}},{"$f":"K29+K25+K24+K21","v":{"v":426,"d":"426.000"}},{"$f":"L29+L25+L24+L21+L7","v":{"v":27.083999999999996,"d":"27.084"}},{"v":159.56,"d":"159.560"},{"v":5.341729999999999,"d":"5.34"},{"v":20,"d":"20.000"},{"v":2.32,"d":"2.320"},{"v":44.49,"d":"44.490"},{"v":14.756450000000001,"d":"14.76"},{"$f":"N30+R30","v":{"v":20.09818,"d":"20.098"}}]

{"sheet":"4","index":3,"n_rows":35,"n_cols":19,"rows_kept":35,"merged":[[0,0,0,17],[1,0,1,17],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,3,11],[2,12,2,17],[3,12,3,13],[3,14,3,15],[3,16,3,17],[5,0,12,0],[5,1,12,1],[23,0,26,0],[23,1,26,1],[27,0,29,0],[27,1,29,1],[31,0,33,0],[34,0,34,1]]}
[]
["                                            Использован: Сборник рецептур блюд и кулинарных изделий для предприятий общетвенного питания 1993 и 1996гг.Сборник рецнптур блюд и кулинарный изделий татарской нацинальной кухни 1997г."]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№103","Винегрет овощной ","картофель ",30.1,21.1,null,0.4,0.08,3.26,16,25,{"$f":"D6*K6/1000","v":{"v":0.7525,"d":"0.75"}},null,{"$f":"D6*M6/1000","v":{"v":0,"d":"0.00"}},20,{"$f":"D6*O6/1000","v":{"v":0.602,"d":"0.60"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"свекла ",20,16,null,0.22,0.03,1.36,4.8,15,{"v":0.3,"d":"0.30"},null,{"v":0,"d":"0.00"},15,{"v":0.3,"d":"0.30"},null,0]
[null,null,"Морковь",12.6,10,null,0.13,null,0.7,3.4,35,{"v":0.441,"d":"0.44"},null,{"v":0,"d":"0.00"},25,{"v":0.315,"d":"0.32"},null,0]
[null,null,"капуста",23,15,{"$nulls":5},25,{"v":0.575,"d":"0.58"},null,{"v":0,"d":"0.00"},23,{"v":0.529,"d":"0.53"},null,0]
[null,null,"лук репчатый",17.9,15,null,0.2,null,1.3,6.1,30,{"v":0.537,"d":"0.54"},null,{"v":0,"d":"0.00"},25,{"v":0.44749999999999995,"d":"0.45"},null,0]
[null,null,"огурцы сол.",18.8,15,null,0.2,0.03,0.48,3.9,137,{"v":2.5756,"d":"2.58"},null,{"v":0,"d":"0.00"},50,0.94,null,0]
[null,null,"Масло растительное",7,7,null,null,9.9,null,89.9,140,0.98,57.58,{"v":0.40306000000000003,"d":"0.40"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",0.5,0.5,null,12.8,25.5,null,277,16,{"v":0.008,"d":"0.01"},9.5,{"v":0.00475,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,"100",{"$nulls":5},{"$f":"SUM(L6:L13)","v":{"v":6.169100000000001,"d":"6.17"}},null,{"$f":"SUM(N6:N13)","v":{"v":0.40781,"d":"0.41"}},{"v":158,"d":"158.00"},{"v":3.1334999999999997,"d":"3.13"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["№610","Гуляш из говядины","Говядина",87,74,null,16.89,12.9,null,174.9,440,{"$f":"D15*K15/1000","v":38.28},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},300.82,{"$f":"D15*Q15/1000","v":26.17134}]
[null,null,"Масло растительное",5,5,null,null,4.99,null,44.95,140,{"v":0.7,"d":"0.70"},57.58,{"v":0.2879,"d":"0.29"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Лук репчатый",18,15,null,0.21,"-",1.36,6.15,30,0.54,null,{"v":0,"d":"0.00"},25,0.45,null,0]
[null,null,"Томат",12,12,null,0.43,null,1.87,9.16,70,0.84,70,0.84,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Или томат.паста",4.8,4.8,null,0.23,null,0.97,2.16,70,{"v":0.336,"d":"0.34"},70,{"v":0.336,"d":"0.34"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,3,null,"-","-","-","-",16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масса тушен.мяса",null,50,null,"-",null,"-","-",null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Мука",4,4,null,0.43,0.04,2.72,13.08,40,0.16,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},22.39,0.08956]
[{"$nulls":5},"50/50",{"$f":"SUM(G15:G22)","v":18.19},17.93,6.92,250.40000000000003,806,40.872,207.07999999999998,1.4734,25,0.45,323.21,26.2609]
["№746","Макароны отварные","макароны",51,null,null,3.5,0.37,23.6,114.5,50,{"$f":"D24*K24/1000","v":2.55},26.29,{"$f":"D24*M24/1000","v":{"v":1.34079,"d":"1.3"}},null,{"$f":"D24*O24/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D24*Q24/1000","v":0}]
[null,null,"Соль",3,null,null,"-","-","-","-",16,{"$f":"D25*K25/1000","v":{"v":0.048,"d":"0.05"}},9.5,{"$f":"D25*M25/1000","v":{"v":0.0285,"d":"0.03"}},null,{"$f":"D25*O25/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D25*Q25/1000","v":0}]
[null,null,"Масло слив",5,null,null,0.02,2.5,0.04,23.1,530,{"$f":"D26*K26/1000","v":2.65},447.82,{"$f":"D26*M26/1000","v":{"v":2.2391,"d":"2.24"}},null,{"$f":"D26*O26/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D26*Q26/1000","v":0}]
[null,null,"итого",null,null,150,{"$f":"SUM(G24:G26)","v":3.52},2.87,23.64,137.6,596,5.247999999999999,483.61,3.60839,0,0,0,0]
["№944","Чай с сахаром","Заварка",1,1,null,0.04,"-","-",null,688,{"$f":"D28*K28/1000","v":{"v":0.688,"d":"0.69"}},444.19,{"$f":"D28*M28/1000","v":{"v":0.44419,"d":"0.44"}},null,{"$f":"D28*O28/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D28*Q28/1000","v":0}]
[null,null,"Сахар",15,15,null,0,null,14.9,58,80,{"$f":"D29*K29/1000","v":{"v":1.2,"d":"1.20"}},51.92,{"$f":"D29*M29/1000","v":{"v":0.7788,"d":"0.78"}},null,{"$f":"D29*O29/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D29*Q29/1000","v":0}]
[null,null,"итого",null,null,"200/7",{"$f":"SUM(G28:G29)","v":0.04},{"$f":"SUM(H28:H29)","v":0},14.9,58,0,1.888,496.11,1.22299,0,0,0,0]
[null,"Хлеб","хлеб",40,null,40,12.16,1.44,79.76,180.8,60,{"$f":"D31*K31/1000","v":{"v":2.4,"d":"2.40"}},41.16,{"$f":"D31*M31/1000","v":{"v":1.6463999999999999,"d":"1.65"}},null,{"$f":"D31*O31/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D31*Q31/1000","v":0}]
[]
[null,null,"итого",null,null,50,{"$f":"SUM(G32:G32)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},{"$f":"G14+G23+G27+G30+G31+G33","v":33.91},22.240000000000002,125.22,626.8,1462,{"v":56.577099999999994,"d":"56.58"},1227.9600000000003,{"v":8.35899,"d":"8.36"},183,3.5835,323.21,{"v":26.2609,"d":"26.26"},{"$f":"N34+R34","v":{"v":34.61989,"d":"34.62"}}]
["итого за день"]

{"sheet":"5","index":4,"n_rows":25,"n_cols":19,"rows_kept":25,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,8,0],[3,1,5,1],[9,0,12,0],[9,1,11,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"каша молочная рисовая","рис",33.3,33.3,null,2.07,0.59,11.96,62.01,75,{"$f":"D4*K4/1000","v":{"v":2.4975,"d":"2.50"}},39,{"$f":"D4*M4/1000","v":{"v":1.2986999999999997,"d":"1.30"}},null,{"$f":"D4*O4/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D4*Q4/1000","v":0},{"$f":"N4+P4+R4","v":{"v":1.2986999999999997,"d":"1.30"}}]
[null,null,"молоко",74.5,74.5,null,2.03,2.55,3.42,44.47,62,{"$f":"D5*K5/1000","v":{"v":4.619,"d":"4.62"}},46.34,{"$f":"D5*M5/1000","v":{"v":3.4523300000000003,"d":"3.45"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*Q5/1000","v":0},{"v":3.4523300000000003,"d":"3.45"}]
[null,null,"сахар",7.5,7.5,{"$nulls":3},7.48,28.43,80,{"$f":"D6*K6/1000","v":{"v":0.6,"d":"0.60"}},44.49,{"$f":"D6*M6/1000","v":{"v":0.333675,"d":"0.33"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*Q6/1000","v":0},{"v":0.333675,"d":"0.33"}]
[null,null,"масло сливочное ",5,null,null,0.04,3.63,0.13,33.05,530,{"$f":"D7*K7/1000","v":2.65},null,{"$f":"D7*M7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},447.82,{"$f":"D7*Q7/1000","v":2.2391},{"v":2.2391,"d":"2.24"}]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"$f":"D8*K8/1000","v":{"v":0.016,"d":"0.02"}},9.5,{"$f":"D8*M8/1000","v":{"v":0.0095,"d":"0.01"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0},{"v":0.0095,"d":"0.01"}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G8)","v":4.14},{"$f":"SUM(H4:H8)","v":6.77},{"$f":"SUM(I4:I8)","v":22.99},{"$f":"SUM(J4:J8)","v":{"v":167.95999999999998,"d":"167.96"}},null,{"$f":"SUM(L4:L8)","v":{"v":10.3825,"d":"10.38"}},null,{"$f":"SUM(N4:N8)","v":{"v":5.0942050000000005,"d":"5.09"}},null,{"$f":"SUM(P4:P8)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R4:R8)","v":{"v":2.2391,"d":"2.24"}},{"v":7.333305000000001,"d":"7.33"}]
["№944","Кофейный напиток","Кофейный напит.",4,null,null,0.54,2.16,0.74,24.42,500,{"$f":"D10*K10/1000","v":{"v":2,"d":"2.00"}},null,{"$f":"D10*M10/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D10*O10/1000","v":{"v":0,"d":"0.00"}},560,{"$f":"D10*Q10/1000","v":2.24},2.24]
[null,null,"молоко",100,null,null,2.82,3.2,4.73,58,62,{"$f":"D11*K11/1000","v":{"v":6.2,"d":"6.20"}},null,{"$f":"D11*M11/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D11*O11/1000","v":{"v":0,"d":"0.00"}},46.34,{"$f":"D11*Q11/1000","v":4.634}]
[null,null,"Сахар",11.1,{"$nulls":4},11.088,42.67,80,{"$f":"D12*K12/1000","v":{"v":0.888,"d":"0.89"}},44.46,{"$f":"D12*M12/1000","v":{"v":0.49350599999999994,"d":"0.49"}},null,{"$f":"D12*O12/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D12*Q12/1000","v":0},{"v":0.49350599999999994,"d":"0.49"}]
[{"$nulls":5},200,{"$f":"SUM(G10:G12)","v":3.36},{"$f":"SUM(H10:H12)","v":5.36},{"$f":"SUM(I10:I12)","v":16.558},{"$f":"SUM(J10:J12)","v":125.09},null,{"$f":"SUM(L10:L12)","v":9.088},null,{"$f":"SUM(N10:N12)","v":0.49350599999999994},null,{"$f":"SUM(P10:P12)","v":0},null,{"$f":"SUM(R10:R12)","v":6.8740000000000006},{"v":7.3675060000000006,"d":"7.37"}]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,{"$f":"D14*K14/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D14*M14/1000","v":{"v":2.192,"d":"2.19"}},{"$f":"G14*N14/1000","v":{"v":0,"d":"0.00"}},{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},{"$f":"I14*P14/1000","v":{"v":0,"d":"0.00"}},{"$f":"D14*Q14/1000","v":0},{"v":2.192,"d":"2.19"}]
[null,"Сочни с творогом","Мука",20,20,null,2.06,0.22,0.04,66.8,40,{"$f":"D15*K15/1000","v":{"v":0.8,"d":"0.80"}},22.39,{"$f":"D15*M15/1000","v":{"v":0.44780000000000003,"d":"0.45"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,null,"Сахар",8,8,{"$nulls":3},7.99,30.32,80,0.64,44.46,{"v":0.35568,"d":"0.36"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масло сливочное",8,8,null,0.004,0.66,0.013,5.99,530,4.24,447.02,{"v":3.57616,"d":"3.58"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Яйцо",6.25,6.25,null,0.779,0.63,null,8.54,137.5,{"v":0.859375,"d":"0.86"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},137.5,0.859375]
[null,null,"сметана",2,2,null,0.048,0.06,0.082,0.59,170,0.34,46.34,{"v":0.09268000000000001,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"соль",0.01,0.01,{"$nulls":5},16,{"v":0.00016,"d":"0.00"},9,{"v":8.9999999999999992E-5,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"творог",16.5,16.5,null,2.76,1.43,0.33,26.24,300,4.95,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},278.9,4.60185]
[null,null,"Яйцо",4,4,null,0.51,0.024,null,5.46,137.5,0.55,137.5,0.55,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Сахар",3.5,3.5,55,null,null,3.5,13.27,80,0.28,44.46,{"v":0.15561000000000003,"d":"0.16"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,75,{"$f":"SUM(G15:G23)","v":6.161},3.024,11.955,157.21000000000004,1491,12.659535,751.1700000000001,5.17802,0,0,416.4,5.461225,{"v":10.639244999999999,"d":"10.64"}]
[null,"итого за день",{"$nulls":4},{"$f":"G20+G14+G13+G9","v":{"v":7.5,"d":"7.50"}},{"$f":"H20+H14+H13+H9","v":13.33},{"$f":"I20+I14+I13+I9","v":{"v":85.548,"d":"85.55"}},{"$f":"J20+J14+J13+J9","v":{"v":460.24999999999994,"d":"460.25"}},{"$f":"K20+K14+K13+K9","v":{"v":76,"d":"76.00"}},{"$f":"L24+#REF!+L13+L9","v":{"$error":"#REF!"}},{"$f":"M24+#REF!+M13+M9","v":{"$error":"#REF!"}},{"$f":"N24+#REF!+N13+N9","v":{"$error":"#REF!"}},{"$f":"O24+#REF!+O13+O9","v":{"$error":"#REF!"}},{"$f":"P24+#REF!+P13+P9","v":{"$error":"#REF!"}},{"$f":"Q24+#REF!+Q13+Q9","v":{"$error":"#REF!"}},{"$f":"R24+#REF!+R13+R9","v":{"$error":"#REF!"}},{"$f":"S24+#REF!+S13+S9","v":{"$error":"#REF!"}}]

{"sheet":"6","index":5,"n_rows":30,"n_cols":20,"rows_kept":30,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[14,0,24,0],[14,1,24,1],[25,0,27,0]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата",null,"Масса порцый обучающихся   возрастных","в граммах           двух          групп"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№196","Рассольник домашний","Капуста",25,20,null,{"v":0.45,"d":"0.5"},{"v":0.02,"d":"0.0"},{"v":1.14,"d":"1.1"},5.4,{"v":25,"d":"25.0"},{"$f":"D4*K4/1000","v":0.625},null,{"$f":"M4*D4/1000","v":0},23,{"$f":"D4*O4/1000","v":0.575},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"Картофель",100,72,null,{"v":2,"d":"2.0"},{"v":0.29,"d":"0.3"},{"v":12.46,"d":"12.5"},57.6,{"v":25,"d":"25.0"},{"$f":"D5*K5/1000","v":2.5},null,{"$f":"M5*D5/1000","v":0},20,{"$f":"D5*O5/1000","v":2},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"Морковь",{"v":12.5,"d":"13"},10,null,{"v":0.16,"d":"0.2"},{"v":0.009,"d":"0.0"},{"v":0.81,"d":"0.8"},{"v":3.26,"d":"3.3"},{"v":25,"d":"25.0"},0.3125,null,0,25,0.3125,null,0]
[null,null,"Лук репчатый",12,10,null,{"v":0.17,"d":"0.2"},0.9,{"v":0.804,"d":"0.8"},{"v":4.13,"d":"4.1"},{"v":30,"d":"30.0"},0.36,null,0,25,0.3,null,0]
[null,null,"Огурцы соленые",{"v":16.7,"d":"17"},15,null,{"v":0.13,"d":"0.1"},{"v":0.016,"d":"0.0"},{"v":0.384,"d":"0.4"},2.4,{"v":137,"d":"137.0"},2.2879,null,0,50,0.835,null,0]
[null,null,"Масло сливочное",5,5,null,{"v":0.04,"d":"0.0"},{"v":3.63,"d":"3.6"},{"v":0.13,"d":"0.1"},{"v":33.05,"d":"33.1"},{"v":530,"d":"530.0"},2.65,447.02,2.2351,null,0,null,0]
[null,null,"Бульон",{"v":0.179,"d":"0"},null,null,0.7,{"v":0.17,"d":"0.2"},null,{"v":5.25,"d":"5.3"},null,0,null,0,null,0,null,0]
[null,null,"Соль",1,null,null,"-","-","-","-",{"v":16,"d":"16.0"},0.016,9.5,0.0095,null,0,null,0]
[null,null,"Мясо",54,{"v":40.5,"d":"41"},null,{"v":10,"d":"10.0"},{"v":6.48,"d":"6.5"},"-",{"v":88.29,"d":"88.3"},{"v":440,"d":"440.0"},23.76,null,0,null,0,300.82,16.24428]
[null,null,"Сметана 15% ж",10,10,10,{"v":0.24,"d":"0.2"},{"v":2,"d":"2.0"},{"v":0.32,"d":"0.3"},{"v":20.64,"d":"20.6"},{"v":170,"d":"170.0"},1.7,null,0,null,0,147.89,1.4788999999999999]
[{"$nulls":5},"250/25",{"$f":"SUM(G4:G13)","v":{"v":13.89,"d":"13.9"}},{"$f":"SUM(H4:H13)","v":{"v":13.515,"d":"13.5"}},{"v":16.048000000000002,"d":"16.0"},{"v":220.01999999999998,"d":"220.0"},{"v":1398,"d":"1398.0"},{"v":34.211400000000005,"d":"34.2"},null,{"v":2.2446,"d":"2.2"},null,{"v":4.0225,"d":"4.0"},null,{"v":17.72318,"d":"17.7"}]
[null,"Буккен с  капустой ","Мука",30,null,null,3.09,0.33,20.6,100.2,40,{"$f":"D15*K15/1000","v":{"v":1.2,"d":"1.20"}},24.68,{"$f":"D15*M15/1000","v":{"v":0.7404,"d":"0.74"}}]
[null,null,"Яйцо",2.4,2,null,0.25,0.23,0.01,3.14,175,0.42,137.5,0.33]
[null,null,"Молоко йодированное",12,null,null,0.38,1.34,0.38,6.96,62,{"v":0.744,"d":"0.74"},46.34,{"v":0.55608,"d":"0.56"},{"$nulls":3},{"$f":"D17*Q17/1000","v":0}]
[null,null,"Сахар",9.6,{"$nulls":4},9.5,36.3,80,{"v":0.768,"d":"0.77"},44.46,{"v":0.426816,"d":"0.43"},{"$nulls":3},{"$f":"D18*Q18/1000","v":0}]
[null,null,"Дрожжи",1.2,{"$nulls":6},400,0.48,240,{"v":0.288,"d":"0.29"}]
[null,null,"Масло сливочное",2.5,null,null,0.02,1.8,0.03,16.5,530,{"v":1.325,"d":"1.33"},null,{"v":0,"d":"0.00"},null,null,447.02,{"$f":"D20*Q20/1000","v":1.11755}]
[null,null,"Фарш: капуста",75,60,null,1.08,null,2.7,16.2,25,{"v":1.875,"d":"1.88"},null,{"v":0,"d":"0.00"},23,{"$f":"D21*O21/1000","v":{"v":1.725,"d":"1.73"}}]
[null,null,"Лук",3.5,2.9,null,0.04,null,0.26,1.18,35,{"v":0.1225,"d":"0.12"},null,{"v":0,"d":"0.00"},25,{"$f":"D22*O22/1000","v":{"v":0.0875,"d":"0.09"}}]
[null,null,"Соль",1,{"$nulls":6},16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"}]
[null,null,"Масло сливочное",11.9,null,null,0.09,null,0.15,78.6,530,{"v":6.307,"d":"6.31"},null,{"v":0,"d":"0.00"},null,null,447.02,{"$f":"D24*Q24/1000","v":5.319538}]
[{"$nulls":5},90,{"$f":"SUM(G15:G24)","v":4.95},3.7,33.63,259.08,1893,{"v":13.2575,"d":"13.26"},null,{"v":2.350796,"d":"2.35"},null,{"v":1.8125,"d":"1.81"},null,{"v":6.437087999999999,"d":"6.44"}]
[null,"Чай с сахаром","Заварка",1,1,null,0,{"$nulls":3},688,{"$f":"D26*K26/1000","v":{"v":0.688,"d":"0.69"}},200,{"$f":"D26*M26/1000","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D26*O26/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D26*Q26/1000","v":0}]
[null,null,"Сахар",15,15,null,{"$f":"SUM(F27)","v":0},null,14.9,56.8,80,{"$f":"D27*K27/1000","v":{"v":1.2,"d":"1.20"}},44.46,{"$f":"D27*M27/1000","v":{"v":0.6668999999999999,"d":"0.67"}},null,{"$f":"D27*O27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*Q27/1000","v":0}]
[null,null,"итого",null,null,200,{"$f":"SUM(G26:G27)","v":0},{"$f":"SUM(H26:H27)","v":0},14.9,56.8,null,1.888,244.46,0.8669,0,0,0,0]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,{"$f":"D29*K29/1000","v":{"v":2.4,"d":"2.40"}},44.98,{"$f":"D29*M29/1000","v":{"v":1.7992,"d":"1.80"}},null,{"$f":"D29*O29/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D29*Q29/1000","v":0}]
["итого за день",{"$nulls":5},{"$f":"G29+G28+G25+G14","v":{"v":18.84,"d":"18.8"}},{"v":18.415,"d":"18.4"},{"v":110.578,"d":"110.6"},{"v":703.0999999999999,"d":"703.1"},{"v":3351,"d":"3351.0"},{"v":51.7569,"d":"51.8"},{"v":289.44,"d":"289.4"},{"v":7.261496,"d":"7.3"},{"v":0,"d":"0.0"},{"v":5.835,"d":"5.8"},{"v":0,"d":"0.0"},{"v":24.160268,"d":"24.2"},{"$f":"N30+R30","v":{"v":31.421764,"d":"31.4"}}]

{"sheet":"7","index":6,"n_rows":24,"n_cols":19,"rows_kept":24,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,8,0],[3,1,8,1],[9,0,18,0],[9,1,18,1],[19,0,21,0],[19,1,21,1],[23,0,23,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№29","Салат из св.капусты","Капуста",99.6,79,null,1.4,null,3.7,21.3,25,{"$f":"D4*K4/1000","v":2.49},null,{"$f":"D4*M4/1000","v":{"v":0,"d":"0.00"}},23,{"$f":"D4*O4/1000","v":{"v":2.2908,"d":"2.29"}},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"Лук",12.5,10,null,0.14,null,0.91,4.1,30,{"$f":"D5*K5/1000","v":{"v":0.375,"d":"0.38"}},null,{"$f":"D5*M5/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D5*O5/1000","v":{"v":0.3125,"d":"0.31"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"Морковь ",12.5,10,null,0.1,null,0.7,3.4,35,{"$f":"D6*K6/1000","v":{"v":0.4375,"d":"0.44"}},null,{"$f":"D6*M6/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D6*O6/1000","v":{"v":0.3125,"d":"0.31"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"Сахар",5,5,{"$nulls":3},4.9,18.9,80,{"$f":"D7*K7/1000","v":{"v":0.4,"d":"0.40"}},44.46,{"$f":"D7*M7/1000","v":{"v":0.2223,"d":"0.22"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*Q7/1000","v":0}]
[null,null,"Масло растительное",5,5,null,null,4.99,null,44.9,140,{"$f":"D8*K8/1000","v":{"v":0.7,"d":"0.70"}},57.58,{"$f":"D8*M8/1000","v":{"v":0.2879,"d":"0.29"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[{"$nulls":5},100,{"$f":"SUM(G4:G8)","v":1.6400000000000001},{"$f":"SUM(H4:H8)","v":4.99},{"$f":"SUM(I4:I8)","v":10.21},{"$f":"SUM(J4:J8)","v":92.6},null,{"$f":"SUM(L4:L8)","v":{"v":4.4025,"d":"4.40"}},null,{"$f":"SUM(N4:N8)","v":{"v":0.5102,"d":"0.51"}},null,{"$f":"SUM(P4:P8)","v":{"v":2.9158,"d":"2.92"}},null,{"$f":"SUM(R4:R8)","v":{"v":0,"d":"0.00"}}]
["№326","Плов с мясом говядины ","мясо (говядины)",59.4,47.4,null,18.4,11.9,null,161.9,440,{"$f":"D10*K10/1000","v":{"v":26.136,"d":"26.14"}},null,{"$f":"D10*M10/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D10*O10/1000","v":{"v":0,"d":"0.00"}},300.82,{"$f":"D10*Q10/1000","v":17.868707999999998}]
[null,null,"крупа рисовая",54,40,{"$nulls":3},5.99,215.2,75,4.05,39,{"v":2.106,"d":"2.11"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"лук репчатый",10,6,{"$nulls":3},1.04,4.13,30,{"v":0.3,"d":"0.30"},null,{"v":0,"d":"0.00"},25,0.25,null,0]
[null,null,"соль ",1,1,{"$nulls":5},16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"морковь ",15,11.4,{"$nulls":3},1.09,5.17,35,{"v":0.525,"d":"0.53"},null,{"v":0,"d":"0.00"},25,{"v":0.375,"d":"0.38"},null,0]
[null,null,"томат-пюре",10,9,null,0.07,null,null,15.3,70,{"v":0.7,"d":"0.70"},70,{"v":0.7,"d":"0.70"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"масло сливочное ",6,6,null,null,4.99,null,44.85,530,3.18,447.02,{"v":2.68212,"d":"2.68"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"масса туш мяса",null,null,30,{"$nulls":5},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null," масса гарнира",null,null,120,{"$nulls":5},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,150,{"$f":"SUM(G10:G18)","v":18.47},{"$f":"SUM(H10:H18)","v":16.89},8.120000000000001,446.55000000000007,null,{"v":34.907,"d":"34.91"},null,{"v":5.4976199999999995,"d":"5.50"},null,{"v":0.625,"d":"0.63"},null,{"v":17.868707999999998,"d":"17.87"}]
["№944","Чай с сахаром","Заварка",1,1,{"$nulls":3},"-","-",688,{"$f":"D20*K20/1000","v":{"v":0.688,"d":"0.69"}},260,{"$f":"D20*M20/1000","v":0.26},null,{"$f":"D20*O20/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D20*Q20/1000","v":0}]
[null,null,"Сахар",15,15,{"$nulls":3},14.9,56.8,80,{"$f":"D21*K21/1000","v":{"v":1.2,"d":"1.20"}},44.49,{"$f":"D21*M21/1000","v":{"v":0.66735,"d":"0.67"}},null,{"$f":"D21*O21/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D21*Q21/1000","v":0}]
[{"$nulls":5},200,{"$f":"SUM(G20:G21)","v":0},{"$f":"SUM(H20:H21)","v":0},14.9,56.8,null,1.888,null,0.92735,null,0,null,0]
[null,"хлеб ","хлеб",40,40,40,6.96,1.2,46,167.2,60,{"$f":"D23*K23/1000","v":{"v":2.4,"d":"2.40"}},44.98,{"$f":"D23*M23/1000","v":{"v":1.7992,"d":"1.80"}},null,{"$f":"D23*O23/1000","v":{"v":0,"d":"0.00"}},{"$f":"I23*P23/1000","v":{"v":0,"d":"0.00"}},{"$f":"D23*Q23/1000","v":0}]
["итого за день",{"$nulls":5},{"$f":"G23+G22+G19+G9","v":27.07},{"$f":"H23+H22+H19+H9","v":23.08},79.22999999999999,763.1500000000001,60,43.5975,44.98,{"v":8.734369999999998,"d":"8.73"},0,3.5408,0,{"v":17.868707999999998,"d":"17.87"},{"$f":"N24+R24","v":{"v":26.603077999999996,"d":"26.60"}}]

{"sheet":"8","index":7,"n_rows":22,"n_cols":19,"rows_kept":22,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,8,0],[3,1,8,1],[9,0,11,0],[9,1,11,1],[13,0,19,0],[13,1,19,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Каша манная молочная","маннка",33.3,33.3,null,3.4,0.33,22.5,109.2,52,{"$f":"D4*K4/1000","v":{"v":1.7315999999999998,"d":"1.73"}},24,{"$f":"D4*M4/1000","v":{"v":0.7991999999999999,"d":"0.80"}},null,{"$f":"D4*O4/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"молоко",73.8,73.8,null,2.03,2.55,3.42,44.47,62,{"$f":"D5*K5/1000","v":{"v":4.5756,"d":"4.58"}},46.34,{"$f":"D5*M5/1000","v":{"v":3.4198920000000004,"d":"3.42"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"сахар",7.5,7.5,{"$nulls":3},7.48,28.43,80,{"$f":"D6*K6/1000","v":{"v":0.6,"d":"0.60"}},44.46,{"$f":"D6*M6/1000","v":{"v":0.33344999999999997,"d":"0.33"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"масло сливочное ",5,null,null,0.04,3.63,0.13,33.05,530,{"$f":"D7*K7/1000","v":2.65},null,{"$f":"D7*M7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},447.02,{"$f":"D7*Q7/1000","v":2.2351}]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"$f":"D8*K8/1000","v":{"v":0.016,"d":"0.02"}},9.5,{"$f":"D8*M8/1000","v":{"v":0.0095,"d":"0.01"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G8)","v":5.47},{"$f":"SUM(H4:H8)","v":6.51},{"$f":"SUM(I4:I8)","v":{"v":33.53000000000001,"d":"33.53"}},{"$f":"SUM(J4:J8)","v":{"v":215.15000000000003,"d":"215.15"}},null,{"$f":"SUM(L4:L8)","v":{"v":9.5732,"d":"9.57"}},null,{"$f":"SUM(N4:N8)","v":{"v":4.562042,"d":"4.56"}},null,{"$f":"SUM(P4:P8)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R4:R8)","v":{"v":2.2351,"d":"2.24"}}]
["№944","Компот из св.яблок","Яблоки",25,22,null,0.1,0.09,2.2,9.9,90,{"$f":"D10*K10/1000","v":2.25},null,{"$f":"D10*M10/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D10*O10/1000","v":{"v":0,"d":"0.00"}},35,{"$f":"D10*Q10/1000","v":0.875}]
[null,null,"Сахар",20,20,{"$nulls":3},19.96,75.8,80,{"$f":"D11*K11/1000","v":{"v":1.6,"d":"1.60"}},44.46,{"$f":"D11*M11/1000","v":{"v":0.8892,"d":"0.89"}},null,{"$f":"D11*O11/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D11*Q11/1000","v":0}]
[{"$nulls":5},200,{"$f":"SUM(G10:G11)","v":0.1},{"$f":"SUM(H10:H11)","v":0.09},22.16,85.7,null,3.85,null,0.8892,null,0,null,0.875]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,{"$f":"D13*K13/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D13*M13/1000","v":{"v":2.192,"d":"2.19"}},null,{"$f":"D13*O13/1000","v":{"v":0,"d":"0.00"}},{"$f":"I13*P13/1000","v":{"v":0,"d":"0.00"}},{"$f":"D13*Q13/1000","v":0}]
["№102","Запеканка рисовая с творогом","творог",20,20,null,3.38,1.87,0.4,32.2,300,{"$f":"D14*K14/1000","v":{"v":6,"d":"6.00"}},null,{"$f":"D14*M14/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},278.89,{"$f":"D14*Q14/1000","v":5.577799999999999}]
[null,null,"Сахар",7.5,7.5,{"$nulls":3},7.4,28.4,80,{"v":0.6,"d":"0.60"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},44.46,0.33344999999999997]
[null,null,"Масло сливочное",5,5,null,0.04,3.36,0.13,33.05,530,2.65,447.02,{"v":2.2351,"d":"2.24"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Яйцо",5,5,null,0.635,0.575,0.01,7.85,175,{"v":0.875,"d":"0.88"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},137.5,0.6875]
[null,null,"Крупа рисовая",24,24,null,1.68,0.25,15.18,78.4,75,{"v":1.8,"d":"1.80"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},39,0.936]
[null,null,"сметана",5,5,null,0.14,1,0.16,10.3,170,0.85,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},147.89,0.7394499999999999]
[null,null,"Масло слив",10,10,null,0.08,7.25,0.26,66.1,530,{"v":5.3,"d":"5.30"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},447.02,4.4702]
[null,null,"итого",null,null,60,{"$f":"SUM(G14:G20)","v":5.954999999999999},{"$f":"SUM(H14:H20)","v":14.305},23.540000000000003,256.3,1860,18.075,447.02,2.2351,0,0,1094.76,12.744399999999999]
[null,"итого за день",{"$nulls":4},{"$f":"G19+G13+G12+G9","v":5.71},{"$f":"H19+H13+H12+H9","v":{"v":8.8,"d":"8.80"}},{"$f":"I19+I13+I12+I9","v":101.85},{"$f":"J19+J13+J12+J9","v":478.35},{"$f":"K19+K13+K12+K9","v":{"v":230,"d":"230.00"}},{"$f":"L21+#REF!+L12+L9","v":{"$error":"#REF!"}},{"$f":"M21+#REF!+M12+M9","v":{"$error":"#REF!"}},{"$f":"N21+#REF!+N12+N9","v":{"$error":"#REF!"}},{"$f":"O21+#REF!+O12+O9","v":{"$error":"#REF!"}},{"$f":"P21+#REF!+P12+P9","v":{"$error":"#REF!"}},{"$f":"Q21+#REF!+Q12+Q9","v":{"$error":"#REF!"}},{"$f":"R21+#REF!+R12+R9","v":{"$error":"#REF!"}},{"$f":"N22+R22","v":{"$error":"#REF!"}}]

{"sheet":"9","index":8,"n_rows":20,"n_cols":19,"rows_kept":20,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,5,0],[3,1,5,1],[6,0,9,0],[6,1,9,1],[10,0,14,0],[10,1,14,1],[15,0,17,0],[15,1,17,1],[19,0,19,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№273","Икра морковная ","Морковь",117.5,94,null,1.1,0.8,6.1,29.2,{"v":35,"d":"35.00"},{"$f":"D4*K4/1000","v":{"v":4.1125,"d":"4.11"}},null,{"$f":"D4*M4/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D4*O4/1000","v":{"v":2.9375,"d":"2.94"}},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"Масло растительное",7,null,null,"-",9.9,null,89.9,{"v":140,"d":"140.00"},{"$f":"D5*K5/1000","v":0.98},57.58,{"$f":"D5*M5/1000","v":{"v":0.40306000000000003,"d":"0.40"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G5)","v":1.1},10.700000000000001,6.1,119.10000000000001,175,5.092499999999999,57.58,0.40306000000000003,25,2.9375,0,0]
[null,"Курица\"Охлажденная\" тушеная","Курица\"Охлажденная\"",102,73,null,28.61,17.7,0.55,201.6,200,{"$f":"D7*K7/1000","v":{"v":20.4,"d":"20.40"}},null,{"$f":"D7*M7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},{"v":152,"d":"152.00"},{"$f":"D7*Q7/1000","v":15.504}]
[null,null,"Соль",2,2,{"$nulls":5},16,{"$f":"D8*K8/1000","v":{"v":0.032,"d":"0.03"}},9.5,{"$f":"D8*M8/1000","v":{"v":0.019,"d":"0.02"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,null,"Масло растительное",2,2,null,null,0.24,null,22.45,140,{"$f":"D9*K9/1000","v":0.28},57.58,{"$f":"D9*M9/1000","v":{"v":0.11516,"d":"0.12"}},null,{"$f":"D9*O9/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D9*Q9/1000","v":0}]
[{"$nulls":5},"50",{"$f":"SUM(G7:G9)","v":28.61},{"$f":"SUM(H7:H9)","v":{"v":17.939999999999998,"d":"17.94"}},0.55,{"v":224.04999999999998,"d":"224.05"},{"v":356,"d":"356.00"},{"v":20.712,"d":"20.71"},67.08,{"v":0.13416,"d":"0.13"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":152,"d":"152.00"},{"v":15.504,"d":"15.50"}]
["№442","картофельное пюре ","картофель ",233,null,null,2,0.4,16.3,80,25,{"$f":"D11*K11/1000","v":{"v":5.825,"d":"5.83"}},null,{"$f":"D11*M11/1000","v":{"v":0,"d":"0.00"}},20,{"$f":"D11*O11/1000","v":4.66},null,{"$f":"D11*Q11/1000","v":0}]
[null,null,"молоко ",23.7,null,null,6.4,0.39,0.74,8.2,62,{"$f":"D12*K12/1000","v":{"v":1.4693999999999998,"d":"1.47"}},46.34,{"$f":"D12*M12/1000","v":{"v":1.098258,"d":"1.10"}},null,{"$f":"D12*O12/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D12*Q12/1000","v":0}]
[null,null,"Соль",1.5,null,null,"-","-","-","-",16,{"$f":"D13*K13/1000","v":{"v":0.024,"d":"0.02"}},9.5,{"$f":"D13*M13/1000","v":{"v":0.01425,"d":"0.01"}},null,{"$f":"D13*O13/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D13*Q13/1000","v":0}]
[null,null,"Масло слив",5,null,null,0.02,2.5,0.04,23.1,530,{"$f":"D14*K14/1000","v":2.65},447.02,{"$f":"D14*M14/1000","v":{"v":2.2351,"d":"2.24"}},null,{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D14*Q14/1000","v":0}]
[null,null,"итого",null,null,150,{"$f":"SUM(G11:G14)","v":8.42},{"$f":"SUM(H11:H14)","v":3.29},17.08,111.30000000000001,633,9.968399999999999,502.86,3.347608,20,4.66,0,0]
[944,"Чай  с сахаром","Заварка",1,1,null,null,"-","-","-",688,{"$f":"D16*K16/1000","v":{"v":0.688,"d":"0.69"}},200,{"$f":"D16*M16/1000","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*Q16/1000","v":0}]
[null,null,"Сахар",15,15,null,null,"-",14.9,56.8,80,{"$f":"D17*K17/1000","v":{"v":1.2,"d":"1.20"}},44.46,{"$f":"D17*M17/1000","v":{"v":0.6668999999999999,"d":"0.67"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D17*Q17/1000","v":0}]
[null,null,"итого",null,null,200,{"$f":"SUM(G16:G17)","v":0},{"$f":"SUM(H16:H17)","v":0},14.9,56.8,null,1.888,null,0.8669,null,0,null,0]
[null,"хлеб ","хлеб",40,40,40,6.96,1.2,46,167.2,60,{"$f":"D19*K19/1000","v":{"v":2.4,"d":"2.40"}},35.77,{"$f":"D19*M19/1000","v":{"v":1.4308,"d":"1.43"}},null,{"$f":"D19*O19/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D19*Q19/1000","v":0}]
["итого за день",{"$nulls":5},{"$f":"G6+G10+G15+G18+G19","v":{"v":45.09,"d":"45.1"}},{"$f":"H6+H10+H15+H18+H19","v":{"v":33.13,"d":"33.1"}},{"v":84.63,"d":"84.6"},{"v":678.45,"d":"678.5"},{"v":1224,"d":"1224.0"},{"v":40.06089999999999,"d":"40.1"},{"v":663.29,"d":"663.3"},{"v":6.182528,"d":"6.2"},{"v":45,"d":"45.0"},{"v":7.5975,"d":"7.6"},{"v":152,"d":"152.0"},{"v":15.504,"d":"15.5"},{"$f":"N20+R20","v":{"v":21.686528,"d":"21.7"}}]

{"sheet":"10","index":9,"n_rows":31,"n_cols":19,"rows_kept":31,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,8,0],[3,1,7,1],[8,1,13,1],[16,0,19,0],[18,1,19,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№416","Свекла с растительным маслом","свекла ",116,null,null,1.1,null,5.43,28.9,15,{"$f":"D4*K4/1000","v":1.74},null,{"$f":"D4*M4/1000","v":{"v":0,"d":"0.00"}},15,{"$f":"D4*O4/1000","v":1.74},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"соль",0.5,{"$nulls":6},16,{"$f":"D5*K5/1000","v":{"v":0.008,"d":"0.01"}},9.5,{"$f":"D5*M5/1000","v":{"v":0.00475,"d":"0.00"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"масло растительное ",10,10,null,{"$f":"SUM(F6)","v":0},9.9,null,89.9,140,{"$f":"D6*K6/1000","v":{"v":1.4,"d":"1.40"}},57.58,{"$f":"D6*M6/1000","v":{"v":0.5758,"d":"0.58"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G6)","v":1.1},9.9,{"v":5.43,"d":"5.4"},{"v":118.80000000000001,"d":"118.8"},{"v":171,"d":"171.0"},{"v":3.1479999999999997,"d":"3.1"},{"v":67.08,"d":"67.1"},{"v":0.58055,"d":"0.6"},{"v":15,"d":"15.0"},{"v":1.74,"d":"1.7"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$nulls":11},{"$f":"D8*K8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*M8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,"Рыба тушеная","рыбные изделия",86,50,null,27.4,5.24,0,110,170,14.62,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":169,"d":"169.0"},14.534]
[null,null,"Масло растительное",4,4,null,null,5.99,0,53.94,140,0.56,57.58,{"v":0.23032,"d":"0.23"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Мука пшеничная",4,4,null,0.62,0.06,4.13,20.04,40,0.16,22.39,{"v":0.08956,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,1,{"$nulls":5},16,{"v":0.016,"d":"0.02"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"специи",{"v":0.02,"d":"0"},{"v":0.02,"d":"0"},{"$nulls":6},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[{"$nulls":5},"50",{"$f":"SUM(G9:G13)","v":28.02},{"$f":"SUM(H9:H13)","v":{"v":11.290000000000001,"d":"11.29"}},4.13,183.98,{"v":366,"d":"366.00"},{"v":15.356,"d":"15.36"},null,{"v":0.32938,"d":"0.33"},null,{"v":0,"d":"0.00"},null,{"v":14.534,"d":"14.53"}]
[null,"Каша пшеничная","Крупа пшеничная",33.3,33.3,null,5.9,1.65,30.95,167.5,42,{"$f":"D15*K15/1000","v":{"v":1.3985999999999998,"d":"1.40"}},19,{"$f":"D15*M15/1000","v":{"v":0.6326999999999999,"d":"0.63"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,null,"Масло сливочное",5,5,null,0.04,3.6,0.06,33.05,530,{"$f":"D16*K16/1000","v":2.65},447.05,{"$f":"D16*M16/1000","v":{"v":2.23525,"d":"2.24"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*Q16/1000","v":0}]
["№746",null,"Соль",1,1,null,"-","-",null,null,16,{"$f":"D17*K17/1000","v":{"v":0.016,"d":"0.02"}},9.5,{"$f":"D17*M17/1000","v":{"v":0.0095,"d":"0.01"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D17*Q17/1000","v":0}]
[null,null,"итого",null,null,150,{"$f":"SUM(G15:G17)","v":5.94},{"$f":"SUM(H15:H17)","v":5.25},31.009999999999998,200.55,588,4.0645999999999995,475.55,2.87745,0,0,0,0]
[null,"Соус томатный","Бульон",50,null,null,{"v":0.41,"d":"0.4"},{"v":1.03,"d":"1.0"},{"v":0.61,"d":"0.6"},{"v":1.85,"d":"1.9"},null,{"$f":"D19*K19/1000","v":0},null,{"$f":"D19*M19/1000","v":0},null,{"$f":"D19*O19/1000","v":0},null,{"$f":"D19*Q19/1000","v":0}]
[null,null,"Масло растительное",1,{"$nulls":3},{"v":0.99,"d":"1.0"},null,{"v":8.99,"d":"9.0"},{"v":140,"d":"140.0"},{"$f":"D20*K20/1000","v":0.14},57.58,{"$f":"D20*M20/1000","v":0.05758},null,{"$f":"D20*O20/1000","v":0},null,{"$f":"D20*Q20/1000","v":0}]
["№459",null,"Мука",{"v":2.5,"d":"3"},null,null,{"v":0.26,"d":"0.3"},{"v":0.02,"d":"0.0"},{"v":1.71,"d":"1.7"},{"v":8.35,"d":"8.4"},{"v":40,"d":"40.0"},0.1,22.39,0.055975000000000004,null,0,null,0]
[null,null,"Томат",3,null,null,{"v":0.18,"d":"0.2"},"-",{"v":0.62,"d":"0.6"},3.4,{"v":70,"d":"70.0"},0.21,70,0.21,null,0,null,0]
[null,null,"Морковь",5,4,null,{"v":0.05,"d":"0.1"},{"v":0,"d":"0.0"},{"v":0.28,"d":"0.3"},{"v":1.32,"d":"1.3"},{"v":35,"d":"35.0"},0.175,null,0,25,0.125,null,0]
[null,null,"Лук репчатый",{"v":1.2,"d":"1"},1,null,{"v":0.01,"d":"0.0"},"-",{"v":0.09,"d":"0.1"},{"v":0.41,"d":"0.4"},{"v":30,"d":"30.0"},0.036,null,0,25,0.03,null,0]
[null,null,"соль",{"v":0.25,"d":"0"},{"v":0.25,"d":"0"},null,"-","-",{"v":0.79,"d":"0.8"},{"v":3.03,"d":"3.0"},{"v":16,"d":"16.0"},0.004,9.5,0.002375,null,0,null,0]
[{"$nulls":6},{"$f":"SUM(G19:G25)","v":{"v":0.9099999999999999,"d":"0.9"}},{"v":2.04,"d":"2.0"},4.1,{"v":27.349999999999998,"d":"27.4"},{"v":331,"d":"331.0"},{"v":0.665,"d":"0.7"},{"v":159.47,"d":"159.5"},{"v":0.32593,"d":"0.3"},{"v":50,"d":"50.0"},{"v":0.155,"d":"0.2"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,"Чай с сахаром","Заварка",1,1,null,null,"-","-","-",688,{"$f":"D27*K27/1000","v":{"v":0.688,"d":"0.69"}},200,{"$f":"D27*M27/1000","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D27*O27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*Q27/1000","v":0}]
[null,null,"Сахар",15,15,null,0,"-",14.9,56.8,80,{"$f":"D28*K28/1000","v":{"v":1.2,"d":"1.20"}},44.46,{"$f":"D28*M28/1000","v":{"v":0.6668999999999999,"d":"0.67"}},null,{"$f":"D28*O28/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D28*Q28/1000","v":0}]
[944,null,"итого",null,null,200,{"$f":"SUM(G27:G28)","v":0},{"$f":"SUM(H27:H28)","v":0},14.9,56.8,0,1.888,244.46,0.8669,0,0,0,0]
[null,"хлеб иодированный","хлеб",40,40,40,6.96,1.2,46,167.2,60,{"$f":"D30*K30/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D30*M30/1000","v":{"v":2.192,"d":"2.19"}},null,{"$f":"D30*O30/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D30*Q30/1000","v":0}]
[null,"итого за день",{"$nulls":4},{"$f":"G30+G29+G26+G18+G14+G7","v":{"v":42.93,"d":"42.9"}},{"$f":"H30+H29+H26+H18+H14+H7","v":{"v":29.68,"d":"29.7"}},{"v":105.57,"d":"105.6"},{"v":754.6800000000001,"d":"754.7"},{"v":1516,"d":"1516.0"},{"v":27.5216,"d":"27.5"},{"v":1001.36,"d":"1001.4"},{"v":7.172210000000001,"d":"7.2"},{"v":65,"d":"65.0"},{"v":1.895,"d":"1.9"},{"v":0,"d":"0.0"},{"v":14.534,"d":"14.5"},{"$f":"N31+R31","v":{"v":21.706210000000002,"d":"21.7"}}]

{"sheet":"11","index":10,"n_rows":19,"n_cols":19,"rows_kept":19,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,8,0],[3,1,8,1],[9,0,12,0],[9,1,11,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Каша молочная геркулесовая","Геркулес",33.3,33.3,null,3.4,0.33,22.5,109.2,53,{"$f":"D4*K4/1000","v":{"v":1.7649,"d":"1.76"}},19,{"$f":"D4*M4/1000","v":{"v":0.6326999999999999,"d":"0.63"}},null,{"$f":"D4*O4/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"молоко",74.5,74.5,null,2.03,2.55,3.42,44.47,62,{"$f":"D5*K5/1000","v":{"v":4.619,"d":"4.62"}},null,{"$f":"D5*M5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},46.34,{"$f":"D5*Q5/1000","v":3.4523300000000003}]
[null,null,"сахар",7.5,7.5,{"$nulls":3},7.48,28.43,80,{"$f":"D6*K6/1000","v":{"v":0.6,"d":"0.60"}},null,{"$f":"D6*M6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},44.46,{"$f":"D6*Q6/1000","v":0.33344999999999997}]
[null,null,"масло сливочное ",5,null,null,0.04,3.63,0.13,33.05,530,{"$f":"D7*K7/1000","v":2.65},null,{"$f":"D7*M7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},447.82,{"$f":"D7*Q7/1000","v":2.2391}]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"$f":"D8*K8/1000","v":{"v":0.016,"d":"0.02"}},9.5,{"$f":"D8*M8/1000","v":{"v":0.0095,"d":"0.01"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G8)","v":5.47},{"$f":"SUM(H4:H8)","v":6.51},{"$f":"SUM(I4:I8)","v":{"v":33.53000000000001,"d":"33.53"}},{"$f":"SUM(J4:J8)","v":{"v":215.15000000000003,"d":"215.15"}},null,{"$f":"SUM(L4:L8)","v":{"v":9.649899999999999,"d":"9.65"}},null,{"$f":"SUM(N4:N8)","v":{"v":0.6421999999999999,"d":"0.64"}},null,{"$f":"SUM(P4:P8)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R4:R8)","v":{"v":6.0248800000000005,"d":"6.02"}}]
["№944","Кисель","Кисель",24,null,null,1.02,null,21.76,87.14,107,{"v":50,"d":"50.00"},50,{"$f":"D10*M10/1000","v":{"v":1.2,"d":"1.20"}},null,{"$f":"D10*O10/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D10*Q10/1000","v":0}]
[null,null,"сахар",10,null,null,1.36,null,29.02,116.19,80,{"$f":"D11*K11/1000","v":{"v":0.8,"d":"0.80"}},null,{"$f":"D11*M11/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D11*O11/1000","v":{"v":0,"d":"0.00"}},44.46,{"$f":"D11*Q11/1000","v":0.4446}]
[{"$nulls":11},{"$f":"D12*K12/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D12*M12/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D12*O12/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D12*Q12/1000","v":0}]
[{"$nulls":5},200,{"$f":"SUM(G10:G12)","v":2.38},{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(I10:I12)","v":50.78},{"$f":"SUM(J10:J12)","v":203.32999999999998},null,{"$f":"SUM(L10:L12)","v":50.8},null,{"$f":"SUM(N10:N12)","v":1.2},null,{"$f":"SUM(P10:P12)","v":0},null,{"$f":"SUM(R10:R12)","v":0.4446}]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,{"$f":"D14*K14/1000","v":{"v":2.4,"d":"2.40"}},54.8,{"$f":"D14*M14/1000","v":{"v":2.192,"d":"2.19"}},null,{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D14*Q14/1000","v":0}]
[null,"Масло слив.","масло сливочное ",10,null,null,0.08,7.25,0.26,66.1,530,{"$f":"D15*K15/1000","v":{"v":5.3,"d":"5.30"}},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},447.02,{"$f":"D15*Q15/1000","v":4.4702}]
[null,"Сыр","Сыр гол.",10,null,null,2.26,2.57,null,33.79,560,{"$f":"D16*K16/1000","v":{"v":5.6,"d":"5.60"}},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},471.46,{"$f":"D16*Q16/1000","v":4.714599999999999}]
[null,"Яйцо","Яйцо",40,null,null,5.08,4.6,0.28,63,175,{"$f":"D17*K17/1000","v":{"v":7,"d":"7.00"}},137.5,{"$f":"D17*M17/1000","v":{"v":5.5,"d":"5.50"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"итого",null,null,75,{"$f":"SUM(G15:G17)","v":7.42},14.42,0.54,162.89,1265,17.9,137.5,5.5,0,0,918.48,9.1848]
[null,"итого за день",{"$nulls":4},{"$f":"G15+G14+G13+G9","v":7.93},{"$f":"H15+H14+H13+H9","v":{"v":14.959999999999999,"d":"14.96"}},{"$f":"I15+I14+I13+I9","v":130.57},{"$f":"J15+J14+J13+J9","v":651.78},{"$f":"K15+K14+K13+K9","v":{"v":590,"d":"590.00"}},{"$f":"L15+L14+L13+L9","v":{"v":68.1499,"d":"68.15"}},{"v":54.8,"d":"54.80"},{"v":4.0342,"d":"4.03"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},447.02,{"v":10.939680000000001,"d":"10.94"},{"$f":"N19+R19","v":{"v":14.973880000000001,"d":"14.97"}}]

{"sheet":"12","index":11,"n_rows":34,"n_cols":19,"rows_kept":34,"merged":[[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,2,11],[1,12,1,17],[2,12,2,13],[2,14,2,15],[2,16,2,17],[4,0,9,0],[4,1,9,1],[10,0,18,0],[10,1,18,1],[19,0,28,0],[19,1,28,1]]}
[]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Салат из свежей  капусты ","капуста",99.6,79,null,1.4,null,3.7,21.3,25,{"$f":"D5*K5/1000","v":2.49},null,{"$f":"D5*M5/1000","v":{"v":0,"d":"0.00"}},17.7,{"$f":"D5*O5/1000","v":{"v":1.7629199999999998,"d":"1.76"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"лук",12.5,10,null,0.14,null,0.91,4.1,30,{"$f":"D6*K6/1000","v":{"v":0.375,"d":"0.38"}},null,{"$f":"D6*M6/1000","v":{"v":0,"d":"0.00"}},22.75,{"$f":"D6*O6/1000","v":{"v":0.284375,"d":"0.28"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"морковь",12.5,10,null,0.1,null,0.7,3.4,35,{"$f":"D7*K7/1000","v":{"v":0.4375,"d":"0.44"}},null,{"$f":"D7*M7/1000","v":{"v":0,"d":"0.00"}},19.5,{"$f":"D7*O7/1000","v":{"v":0.24375,"d":"0.24"}},null,{"$f":"D7*Q7/1000","v":0}]
[null,null,"сахар",5,5,{"$nulls":3},4.9,18.9,80,{"$f":"D8*K8/1000","v":{"v":0.4,"d":"0.40"}},51.92,{"$f":"D8*M8/1000","v":{"v":0.2596,"d":"0.26"}},null,{"$f":"D8*O8/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*Q8/1000","v":0}]
[null,null,"масло растительное ",5,5,null,null,4.99,null,44.9,140,{"$f":"D9*K9/1000","v":{"v":0.7,"d":"0.70"}},81.88,{"$f":"D9*M9/1000","v":{"v":0.4094,"d":"0.41"}},null,{"$f":"D9*O9/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D9*Q9/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G5:G9)","v":1.6400000000000001},{"$f":"SUM(H5:H9)","v":4.99},10.21,92.6,null,{"v":4.4025,"d":"4.40"},null,{"v":0.669,"d":"0.67"},null,{"v":2.2910449999999996,"d":"2.29"},null,{"v":0,"d":"0.00"}]
["№206","Суп  гороховый","Картофель",{"v":66.7,"d":"67"},48,null,{"v":1.33,"d":"1.3"},{"v":0.19,"d":"0.2"},8.2,{"v":38.42,"d":"38.4"},{"v":25,"d":"25.0"},{"$f":"D11*K11/1000","v":1.6675},null,{"$f":"D11*M11/1000","v":0},18.5,{"$f":"D11*O11/1000","v":1.23395},null,{"$f":"D11*Q11/1000","v":0}]
[null,null,"Горох лущеный",{"v":20.5,"d":"21"},20,null,4.6,0.3,10.2,62.8,{"v":34,"d":"34.0"},{"$f":"D12*K12/1000","v":0.697},null,{"$f":"D12*M12/1000","v":0},28,{"$f":"D12*O12/1000","v":0.574},null,{"$f":"D12*Q12/1000","v":0}]
[null,null,"Лук репчатый",12,{"v":10.8,"d":"11"},null,{"v":0.168,"d":"0.2"},0.9,{"v":0.81,"d":"0.8"},{"v":4.13,"d":"4.1"},{"v":30,"d":"30.0"},0.36,null,0,22.75,0.273,null,0]
[null,null,"Морковь",{"v":12.5,"d":"13"},{"v":10.8,"d":"11"},null,{"v":0.16,"d":"0.2"},{"v":0.01,"d":"0.0"},{"v":0.84,"d":"0.8"},3.4,{"v":35,"d":"35.0"},0.4375,null,0,19.5,0.24375,null,0]
[null,null,"Масло сливочное",5,5,null,{"v":0.04,"d":"0.0"},{"v":3.63,"d":"3.6"},{"v":0.13,"d":"0.1"},{"v":33.05,"d":"33.1"},{"v":530,"d":"530.0"},2.65,null,0,null,0,253.4,1.267]
[null,null,"Бульон",{"v":0.175,"d":"0"},{"v":0.175,"d":"0"},null,0.7,0.2,"-",{"v":5,"d":"5.0"},{"v":0,"d":"0.0"},0,null,0,null,0,188,0.0329]
[null,null,"Соль",1,null,null,"-","-","-","-",{"v":16,"d":"16.0"},0.016,10.06,0.010060000000000001,null,0,null,0]
[null,null,"Мясо курицы",52,36,null,{"v":9.72,"d":"9.7"},{"v":6.03,"d":"6.0"},{"v":0.18,"d":"0.2"},{"v":68.52,"d":"68.5"},{"v":200,"d":"200.0"},10.4,null,0,null,0,132.2,6.8744]
[{"$nulls":5},"250/25",{"$f":"SUM(G11:G18)","v":{"v":16.718,"d":"16.7"}},{"$f":"SUM(H11:H18)","v":{"v":11.260000000000002,"d":"11.3"}},{"v":20.359999999999996,"d":"20.4"},{"v":215.32,"d":"215.3"},{"v":870,"d":"870.0"},{"v":16.228,"d":"16.2"},{"v":10.06,"d":"10.1"},{"v":0.010060000000000001,"d":"0.0"},{"v":88.75,"d":"88.8"},{"v":2.3247,"d":"2.3"},{"v":573.5999999999999,"d":"573.6"},{"v":8.174299999999999,"d":"8.2"}]
[null,"Ватрушка с повидлом","мука",38.74,null,null,3.81,0.4,25.48,123.6,{"v":40,"d":"40.00"},1.5496,22.39,0.8673886000000001,null,0,null,0]
[null,null,"Сахар",20,null,null,3.81,0.4,25.48,123.6,{"v":80,"d":"80.00"},1.6,44.46,0.8892,null,0,null,0]
[null,null,"Масло сливочное",1.68,null,null,0.01,1.22,0.04,11.1,{"v":530,"d":"530.00"},0.8904,null,0,null,0,447.02,0.7509935999999999]
[null,null,"Яйцо",20,null,null,2.54,2.3,0.14,31.4,{"v":175,"d":"175.00"},3.5,{"v":137.5,"d":"137.50"},2.75,null,0,null,0]
[null,null,"соль",0.05,{"$nulls":6},{"v":16,"d":"16.00"},0.0008,{"v":9.5,"d":"9.50"},4.7500000000000005E-4,null,0,null,0]
[null,null,"дрожжи",1.1,{"$nulls":6},{"v":400,"d":"400.00"},0.44000000000000006,{"v":240,"d":"240.00"},0.264,null,0,null,0]
[null,null,"повидло",30,null,null,2.08,null,19.59,84.1,{"v":157,"d":"157.00"},4.71,{"v":75,"d":"75.00"},2.25,null,0,null,0]
[null,null,"масло раст.",0.25,{"$nulls":3},0.24,null,2.25,{"v":140,"d":"140.00"},0.035,57.58,0.014395,null,0,null,0]
[null,null,"Выход фарша",75,null,null,"-","-","-","-",null,0,null,0,null,0,null,0]
[null,null,"  ",{"$nulls":3},{"$f":"SUM(G20:G28)","v":12.25},{"v":4.5600000000000005,"d":"4.56"},70.73,{"v":376.04999999999995,"d":"376.05"},{"v":1538,"d":"1538.00"},{"v":12.7258,"d":"12.73"},null,{"$f":"SUM(N20:N28)","v":{"v":7.035458600000001,"d":"7.04"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},447.02,{"v":0.7509935999999999,"d":"0.75"}]
[944,"Чай с сахаром","Заварка",1,1,null,null,"-","-","-",688,0.688,{"v":200,"d":"200.00"},0.2,null,0,null,0]
[null,null,"Сахар",15,15,null,1,"-",14.9,56.8,80,null,44.46,0.6668999999999999,null,0,null,0]
[{"$nulls":5},200,{"$f":"SUM(G30:G31)","v":1},{"$f":"SUM(H30:H31)","v":0},14.9,56.8,0,0.688,244.46,0.8669,0,0,0,0]
[null,"хлеб","хлеб",40,40,40,null,1.2,46,167.2,60,2.4,54.8,2.192,null,0,null,0]
[null,"итого за день",{"$nulls":4},{"$f":"G33+G32+G29+G19","v":{"v":29.968,"d":"29.97"}},{"$f":"H33+H32+H29+H19","v":{"v":17.020000000000003,"d":"17.02"}},{"$f":"I33+I32+I29+I19","v":{"v":151.98999999999998,"d":"151.99"}},{"$f":"J33+J32+J29+J19","v":{"v":815.3699999999999,"d":"815.37"}},{"$f":"K33+K32+K29+K19","v":{"v":2468,"d":"2468.00"}},{"$f":"L33+L32+L29+L19+L7","v":{"v":32.4793,"d":"32.48"}},309.32,{"v":10.1044186,"d":"10.10"},108.25,{"v":2.56845,"d":"2.57"},{"v":1020.6199999999999,"d":"1020.62"},{"v":8.925293599999998,"d":"8.93"},{"$f":"N34+R34","v":{"v":19.0297122,"d":"19.03"}}]

{"sheet":"13","index":12,"n_rows":33,"n_cols":19,"rows_kept":33,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,12,0],[3,1,12,1],[14,0,17,0],[14,1,17,1],[18,0,20,0],[22,0,30,0],[22,1,30,1],[32,0,32,2]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№103","Винегрет овощной ","картофель ",30.1,21.1,null,0.4,0.08,3.26,16,20,{"$f":"D4*K4/1000","v":{"v":0.602,"d":"0.60"}},null,{"$f":"D4*M4/1000","v":{"v":0,"d":"0.00"}},20,{"$f":"D4*O4/1000","v":{"v":0.602,"d":"0.60"}},null,{"$f":"D4*Q4/1000","v":0}]
[null,null,"свекла ",20,16,null,0.22,0.03,1.36,4.8,15,{"v":0.3,"d":"0.30"},null,{"v":0,"d":"0.00"},15,{"v":0.3,"d":"0.30"},null,0]
[null,null,"Морковь",12.6,10,null,0.13,null,0.7,3.4,25,{"v":0.315,"d":"0.32"},null,{"v":0,"d":"0.00"},25,{"v":0.315,"d":"0.32"},null,0]
[null,null,"капуста",23,15,{"$nulls":5},23,{"v":0.529,"d":"0.53"},null,{"v":0,"d":"0.00"},23,{"v":0.529,"d":"0.53"},null,0]
[null,null,"лук репчатый",17.9,15,null,0.2,null,1.3,6.1,25,{"v":0.44749999999999995,"d":"0.45"},null,{"v":0,"d":"0.00"},25,{"v":0.44749999999999995,"d":"0.45"},null,0]
[null,null,"соль ",0.5,0.5,{"$nulls":5},9.5,{"v":0.00475,"d":"0.00"},9.5,{"v":0.00475,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"огурцы сол.",19,17,null,0.2,0.03,0.48,3.9,50,0.95,null,{"v":0,"d":"0.00"},50,0.95,null,0]
[null,null,"Масло растительное",10,10,null,null,9.9,null,89.9,57.58,{"v":0.5758,"d":"0.58"},57.58,{"v":0.5758,"d":"0.58"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",{"v":0.5,"d":"1"},{"v":0.5,"d":"1"},null,12.8,25.5,null,277,9.5,{"v":0.00475,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,"100",{"$nulls":5},{"$f":"SUM(L4:L12)","v":{"v":3.7288,"d":"3.73"}},null,{"$f":"SUM(N4:N12)","v":{"v":0.58055,"d":"0.58"}},{"v":158,"d":"158.00"},{"v":3.1434999999999995,"d":"3.14"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Сосиска отварная","сосиска отварная",53,50,"50",{"$f":"SUM(G12:G12)","v":{"v":12.8,"d":"12.80"}},{"$f":"SUM(H12:H12)","v":{"v":25.5,"d":"25.50"}},{"$f":"SUM(I12:I12)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J12:J12)","v":{"v":277,"d":"277.00"}},{"v":168.9,"d":"168.90"},{"$f":"D14*K14/1000","v":{"v":8.9517,"d":"8.95"}},null,{"$f":"F14*M14/1000","v":{"v":0,"d":"0.00"}},{"$f":"G14*N14/1000","v":{"v":0,"d":"0.00"}},{"$f":"H14*O14/1000","v":{"v":0,"d":"0.00"}},{"v":168.9,"d":"168.90"},{"$f":"Q14*D14/1000","v":{"v":8.9517,"d":"8.95"}}]
["№403","Пюре  гороховое","Горох",48.5,48,null,11.04,0.77,24,150.72,18,{"$f":"D15*K15/1000","v":{"v":0.873,"d":"0.87"}},18,{"$f":"D15*M15/1000","v":{"v":0.873,"d":"0.87"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D15*Q15/1000","v":0}]
[null,null,"Масло сливочное",3.5,3.5,null,0.01,2.54,0.03,23.13,447.02,{"$f":"D16*K16/1000","v":{"v":1.56457,"d":"1.56"}},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},447.02,{"$f":"D16*Q16/1000","v":1.56457}]
[null,null,"Соль",1,null,null,"-","-","-","-",9.5,{"$f":"D17*K17/1000","v":{"v":0.0095,"d":"0.01"}},9.5,{"$f":"D17*M17/1000","v":{"v":0.0095,"d":"0.01"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D17*Q17/1000","v":0}]
[null,null,"итого",null,null,100,{"$f":"SUM(G15:G17)","v":11.049999999999999},{"$f":"SUM(H15:H17)","v":3.31},24.03,173.85,null,{"v":2.44707,"d":"2.45"},null,{"v":0.8825,"d":"0.88"},null,{"v":0,"d":"0.00"},null,{"v":1.56457,"d":"1.56"}]
[null,"Чай с сахаром","Заварка",1,null,null,"-","-","-","-",200,{"$f":"D19*K19/1000","v":{"v":0.2,"d":"0.20"}},200,{"$f":"D19*M19/1000","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D19*O19/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D19*Q19/1000","v":0}]
[null,null,"Сахар",15,null,null,"-","-",14.9,56.8,44.46,{"$f":"D20*K20/1000","v":{"v":0.6668999999999999,"d":"0.67"}},44.46,{"$f":"D20*M20/1000","v":{"v":0.6668999999999999,"d":"0.67"}},null,{"$f":"D20*O20/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D20*Q20/1000","v":0}]
[null,null,"итого",null,null,200,{"$f":"SUM(G19:G20)","v":0},{"$f":"SUM(H19:H20)","v":0},14.9,56.8,null,0.8669,null,0.8669,null,0,null,0]
[null,"Хлеб","Хлеб",40,40,40,6.96,1.2,46,167.2,44.98,{"$f":"D22*K22/1000","v":{"v":1.7992,"d":"1.80"}},null,{"$f":"D22*M22/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D22*O22/1000","v":{"v":0,"d":"0.00"}},44.46]
[null,"Сочник с творогом","Мука",20,20,null,2.06,0.22,0.04,66.8,22.39,{"$f":"D23*K23/1000","v":{"v":0.44780000000000003,"d":"0.45"}},22.39,{"$f":"D23*M23/1000","v":{"v":0.44780000000000003,"d":"0.45"}},null,{"$f":"D23*O23/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D23*Q23/1000","v":0}]
[null,null,"Сахар",8,8,{"$nulls":3},7.99,30.32,44.46,{"v":0.35568,"d":"0.36"},44.46,{"v":0.35568,"d":"0.36"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масло сливочное",8,8,null,0.004,0.66,0.013,5.99,447.02,{"v":3.57616,"d":"3.58"},447.02,{"v":3.57616,"d":"3.58"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Яйцо",6.25,6.25,null,0.779,0.63,null,8.54,137.5,{"v":0.859375,"d":"0.86"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},137.5,0.859375]
[null,null,"сметана",2,2,null,0.048,0.06,0.082,0.59,147,{"v":0.294,"d":"0.29"},46.34,{"v":0.09268000000000001,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"соль",0.01,0.01,{"$nulls":5},9,{"v":8.9999999999999992E-5,"d":"0.00"},9,{"v":8.9999999999999992E-5,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"творог",16.5,16.5,null,2.76,1.43,0.33,26.24,278.9,{"v":4.60185,"d":"4.60"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},278.9,4.60185]
[null,null,"Яйцо",4,4,null,0.51,0.024,null,5.46,137.5,0.55,137.5,0.55,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Сахар",3.5,3.5,55,null,null,3.5,13.27,44.46,{"v":0.15561000000000003,"d":"0.16"},44.46,{"v":0.15561000000000003,"d":"0.16"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",{"$nulls":3},{"$f":"SUM(G23:G31)","v":6.161},{"$f":"SUM(H23:H31)","v":3.024},11.955,157.21000000000004,1268.23,10.840565,751.1700000000001,5.17802,0,0,416.4,5.461225]
["итого ",{"$nulls":5},{"$f":"G22+G21+G18+G14+G13+G32","v":{"v":36.971,"d":"36.97"}},{"v":33.034,"d":"33.03"},{"v":96.885,"d":"96.89"},{"v":832.0600000000001,"d":"832.06"},{"v":1482.1100000000001,"d":"1482.11"},{"v":28.634235000000004,"d":"28.63"},{"$f":"M22+M21+M18+M14+M13+M32","v":{"v":751.1700000000001,"d":"751.17"}},{"v":7.50797,"d":"7.51"},{"v":158,"d":"158.00"},{"v":3.1434999999999995,"d":"3.14"},629.76,{"v":15.977495000000001,"d":"15.98"},{"$f":"N33+R33","v":{"v":23.485465,"d":"23.49"}}]

{"sheet":"Лист1","index":13,"n_rows":33,"n_cols":20,"rows_kept":33,"merged":[[4,0,9,0],[16,1,20,1]]}
[]
[]
[]
[]
["№102","коржики молочные ","Мука",40,40,null,4.12,0.44,27.6,167.6,22.39,{"$f":"D5*K5/1000","v":{"v":0.8956000000000001,"d":"0.90"}},null,{"$f":"D5*M5/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},22.39,{"$f":"D5*Q5/1000","v":0.8956000000000001},{"$f":"N5+P5+R5","v":{"v":0.8956000000000001,"d":"0.90"}}]
[null,null,"Сахар",21.15,21.15,{"$nulls":3},21.1,80.16,44.46,{"v":0.940329,"d":"0.94"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},44.46,0.940329,{"v":0.940329,"d":"0.94"}]
[null,null,"Масло сливочное",9.6,9.6,null,0.08,7.25,0.26,66.1,447.82,{"v":4.299072,"d":"4.30"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},447.82,4.299072,{"v":4.299072,"d":"4.30"}]
[null,null,"Яйцо",2.1,null,null,0.26,0.24,0.01,3.9,129.8,{"v":0.27258000000000004,"d":"0.27"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},137.5,0.28875,{"v":0.28875,"d":"0.29"}]
[null,null,"молоко",7.55,7.55,null,0.21,0.24,0.36,4.37,46.34,{"v":0.34986700000000004,"d":"0.35"},46.34,{"v":0.34986700000000004,"d":"0.35"},null,{"v":0,"d":"0.00"},null,0,{"v":0.34986700000000004,"d":"0.35"}]
[null,null,"Яйцо для смазки",0.09,null,null,0.11,0.1,null,1.41,129.8,{"v":0.011682,"d":"0.01"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},137.5,0.012375,{"v":0.012375,"d":"0.01"}]
[null,null,"Масло растительное",0.25,0.25,null,null,0.249,null,null,51.9,{"v":0.012975,"d":"0.01"},57.58,{"v":0.014395,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0,{"v":0.014395,"d":"0.01"}]
[]
[]
[]
[]
[]
[null,"№746","картофельное пюре ","картофель ",233,150,null,2,0.4,16.3,80,18.5,{"$f":"E17*L17/1000","v":{"v":4.3105,"d":"4.31"}},null,{"$f":"E17*N17/1000","v":{"v":0,"d":"0.00"}},18.5,{"$f":"E17*P17/1000","v":{"v":4.3105,"d":"4.31"}},null,{"$f":"E17*R17/1000","v":0},{"$f":"O17+Q17+S17","v":{"v":4.3105,"d":"4.31"}}]
[{"$nulls":3},"молоко ",23.7,null,null,6.4,0.39,0.74,8.2,37.55,{"$f":"E18*L18/1000","v":{"v":0.8899349999999999,"d":"0.89"}},37.55,{"$f":"E18*N18/1000","v":{"v":0.8899349999999999,"d":"0.89"}},null,{"$f":"E18*P18/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"E18*R18/1000","v":0},{"v":0.8899349999999999,"d":"0.89"}]
[{"$nulls":3},"Соль",1.5,null,null,"-","-","-","-",10.06,{"$f":"E19*L19/1000","v":{"v":0.01509,"d":"0.02"}},10.06,{"$f":"E19*N19/1000","v":{"v":0.01509,"d":"0.02"}},null,{"$f":"E19*P19/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"E19*R19/1000","v":0},{"v":0.01509,"d":"0.02"}]
[{"$nulls":3},"Масло слив",5,null,null,0.02,2.5,0.04,23.1,253.4,{"$f":"E20*L20/1000","v":{"v":1.267,"d":"1.27"}},253.4,{"$f":"E20*N20/1000","v":{"v":1.267,"d":"1.27"}},null,{"$f":"E20*P20/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"E20*R20/1000","v":0},{"v":1.267,"d":"1.27"}]
[{"$nulls":3},"итого",null,null,150,{"$f":"SUM(H17:H20)","v":8.42},{"$f":"SUM(I17:I20)","v":3.29},17.08,111.30000000000001,319.51,6.482525000000001,301.01,2.1720249999999997,18.5,4.3105,0,0,{"v":6.482525,"d":"6.48"}]
[]
[]
[]
[]
[]
[{"$nulls":11},{"$f":"D27*K27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*M27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*O27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*Q27/1000","v":0}]
[null,"Рыба тушеная","рыбные изделия",86,50,null,27.4,5.24,0,110,169,{"v":14.534,"d":"14.53"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":169,"d":"169.0"},14.534]
[null,null,"Масло растительное",4,4,null,null,5.99,0,53.94,51.9,{"v":0.2076,"d":"0.21"},57.58,{"v":0.23032,"d":"0.23"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Мука пшеничная",4,4,null,0.62,0.06,4.13,20.04,19.9,{"v":0.07959999999999999,"d":"0.08"},22.39,{"v":0.08956,"d":"0.09"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,1,{"$nulls":5},9.5,{"v":0.0095,"d":"0.01"},9.5,{"v":0.0095,"d":"0.01"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"специи",{"v":0.02,"d":"0"},{"v":0.02,"d":"0"},{"$nulls":6},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0]
[{"$nulls":5},"50",{"$f":"SUM(G28:G32)","v":28.02},{"$f":"SUM(H28:H32)","v":{"v":11.290000000000001,"d":"11.29"}},4.13,183.98,{"v":250.3,"d":"250.30"},{"v":14.830699999999998,"d":"14.83"},null,{"v":0.32938,"d":"0.33"},null,{"v":0,"d":"0.00"},null,{"v":14.534,"d":"14.53"}]